[ROOT] dt FactResellerSale < WHERE DimResellerId EQ '473' >
61 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO48327_1 | 2906-4A58-AF | PO13717142928 | 100 | 287 | 370 | 473 | 4 | 2023-08-19 | 1466.01 | 36.65 | 2023-08-07 | 1 | 1518.79 | 1 | 1466.01 | 1 | SO48327 | 2023-08-14 | 117.28 | 1518.79 | 1466.01 |
SO48327_2 | 2906-4A58-AF | PO13717142928 | 100 | 287 | 265 | 473 | 4 | 2023-08-19 | 1213.99 | 30.35 | 2023-08-07 | 6 | 187.16 | 1 | 1213.99 | 2 | SO48327 | 2023-08-14 | 97.12 | 1122.94 | 202.33 |
SO48327_3 | 2906-4A58-AF | PO13717142928 | 100 | 287 | 254 | 473 | 4 | 2023-08-19 | 183.94 | 4.60 | 2023-08-07 | 1 | 170.14 | 1 | 183.94 | 3 | SO48327 | 2023-08-14 | 14.72 | 170.14 | 183.94 |
SO48327_4 | 2906-4A58-AF | PO13717142928 | 100 | 287 | 407 | 473 | 4 | 2023-08-19 | 196.81 | 4.92 | 2023-08-07 | 3 | 48.55 | 1 | 196.81 | 4 | SO48327 | 2023-08-14 | 15.74 | 145.64 | 65.60 |
SO48327_5 | 2906-4A58-AF | PO13717142928 | 100 | 287 | 435 | 473 | 4 | 2023-08-19 | 324.45 | 8.11 | 2023-08-07 | 1 | 300.12 | 1 | 324.45 | 5 | SO48327 | 2023-08-14 | 25.96 | 300.12 | 324.45 |
SO48327_6 | 2906-4A58-AF | PO13717142928 | 100 | 287 | 464 | 473 | 4 | 2023-08-19 | 42.39 | 1.06 | 2023-08-07 | 3 | 9.71 | 1 | 42.39 | 6 | SO48327 | 2023-08-14 | 3.39 | 29.14 | 14.13 |
SO48327_7 | 2906-4A58-AF | PO13717142928 | 100 | 287 | 453 | 473 | 4 | 2023-08-19 | 35.99 | 0.90 | 2023-08-07 | 1 | 24.75 | 1 | 35.99 | 7 | SO48327 | 2023-08-14 | 2.88 | 24.75 | 35.99 |
SO49506_1 | A1B2-45C6-A2 | PO13717198252 | 100 | 287 | 422 | 473 | 4 | 2023-11-17 | 202.62 | 5.07 | 2023-11-05 | 3 | 49.98 | 1 | 202.62 | 1 | SO49506 | 2023-11-12 | 16.21 | 149.94 | 67.54 |
SO49506_2 | A1B2-45C6-A2 | PO13717198252 | 100 | 287 | 381 | 473 | 4 | 2023-11-17 | 600.26 | 15.01 | 2023-11-05 | 1 | 605.65 | 1 | 600.26 | 2 | SO49506 | 2023-11-12 | 48.02 | 605.65 | 600.26 |
SO49506_3 | A1B2-45C6-A2 | PO13717198252 | 100 | 287 | 216 | 473 | 4 | 2023-11-17 | 20.19 | 0.50 | 2023-11-05 | 1 | 13.88 | 1 | 20.19 | 3 | SO49506 | 2023-11-12 | 1.61 | 13.88 | 20.19 |
SO50725_1 | 84DA-4CF7-8D | PO13717128221 | 100 | 287 | 254 | 473 | 4 | 2024-02-17 | 183.94 | 4.60 | 2024-02-05 | 1 | 170.14 | 1 | 183.94 | 1 | SO50725 | 2024-02-12 | 14.72 | 170.14 | 183.94 |
SO50725_2 | 84DA-4CF7-8D | PO13717128221 | 100 | 287 | 435 | 473 | 4 | 2024-02-17 | 324.45 | 8.11 | 2024-02-05 | 1 | 300.12 | 1 | 324.45 | 2 | SO50725 | 2024-02-12 | 25.96 | 300.12 | 324.45 |
SO50725_3 | 84DA-4CF7-8D | PO13717128221 | 100 | 287 | 273 | 473 | 4 | 2024-02-17 | 607.00 | 15.17 | 2024-02-05 | 3 | 187.16 | 1 | 607.00 | 3 | SO50725 | 2024-02-12 | 48.56 | 561.47 | 202.33 |
SO50725_4 | 84DA-4CF7-8D | PO13717128221 | 100 | 287 | 417 | 473 | 4 | 2024-02-17 | 648.91 | 16.22 | 2024-02-05 | 2 | 300.12 | 1 | 648.91 | 4 | SO50725 | 2024-02-12 | 51.91 | 600.24 | 324.45 |
SO50725_5 | 84DA-4CF7-8D | PO13717128221 | 100 | 287 | 265 | 473 | 4 | 2024-02-17 | 809.33 | 20.23 | 2024-02-05 | 4 | 187.16 | 1 | 809.33 | 5 | SO50725 | 2024-02-12 | 64.75 | 748.63 | 202.33 |
SO50725_6 | 84DA-4CF7-8D | PO13717128221 | 100 | 287 | 368 | 473 | 4 | 2024-02-17 | 1466.01 | 36.65 | 2024-02-05 | 1 | 1518.79 | 1 | 1466.01 | 6 | SO50725 | 2024-02-12 | 117.28 | 1518.79 | 1466.01 |
SO50725_7 | 84DA-4CF7-8D | PO13717128221 | 100 | 287 | 407 | 473 | 4 | 2024-02-17 | 131.20 | 3.28 | 2024-02-05 | 2 | 48.55 | 1 | 131.20 | 7 | SO50725 | 2024-02-12 | 10.50 | 97.09 | 65.60 |
SO50725_8 | 84DA-4CF7-8D | PO13717128221 | 100 | 287 | 459 | 473 | 4 | 2024-02-17 | 215.98 | 5.40 | 2024-02-05 | 4 | 37.12 | 1 | 215.98 | 8 | SO50725 | 2024-02-12 | 17.28 | 148.48 | 53.99 |
SO50725_9 | 84DA-4CF7-8D | PO13717128221 | 100 | 287 | 224 | 473 | 4 | 2024-02-17 | 5.19 | 0.13 | 2024-02-05 | 1 | 5.23 | 1 | 5.19 | 9 | SO50725 | 2024-02-12 | 0.41 | 5.23 | 5.19 |
SO44099_1 | B4BD-41B2-87 | PO13717176693 | 100 | 287 | 235 | 473 | 4 | 2022-05-20 | 28.84 | 0.72 | 2022-05-08 | 1 | 31.72 | 1 | 28.84 | 1 | SO44099 | 2022-05-15 | 2.31 | 31.72 | 28.84 |
SO44099_2 | B4BD-41B2-87 | PO13717176693 | 100 | 287 | 316 | 473 | 4 | 2022-05-20 | 1749.59 | 43.74 | 2022-05-08 | 2 | 884.71 | 1 | 1749.59 | 2 | SO44099 | 2022-05-15 | 139.97 | 1769.42 | 874.79 |
SO44099_3 | B4BD-41B2-87 | PO13717176693 | 100 | 287 | 317 | 473 | 4 | 2022-05-20 | 874.79 | 21.87 | 2022-05-08 | 1 | 884.71 | 1 | 874.79 | 3 | SO44099 | 2022-05-15 | 69.98 | 884.71 | 874.79 |
SO44099_4 | B4BD-41B2-87 | PO13717176693 | 100 | 287 | 332 | 473 | 4 | 2022-05-20 | 838.92 | 20.97 | 2022-05-08 | 2 | 413.15 | 1 | 838.92 | 4 | SO44099 | 2022-05-15 | 67.11 | 826.29 | 419.46 |
SO44099_5 | B4BD-41B2-87 | PO13717176693 | 100 | 287 | 314 | 473 | 4 | 2022-05-20 | 8587.85 | 214.70 | 2022-05-08 | 4 | 2171.29 | 1 | 8587.85 | 5 | SO44099 | 2022-05-15 | 687.03 | 8685.18 | 2146.96 |
SO44099_6 | B4BD-41B2-87 | PO13717176693 | 100 | 287 | 328 | 473 | 4 | 2022-05-20 | 419.46 | 10.49 | 2022-05-08 | 1 | 413.15 | 1 | 419.46 | 6 | SO44099 | 2022-05-15 | 33.56 | 413.15 | 419.46 |
SO44760_1 | 7817-4F63-9C | PO13717175675 | 100 | 287 | 311 | 473 | 4 | 2022-08-19 | 2146.96 | 53.67 | 2022-08-07 | 1 | 2171.29 | 1 | 2146.96 | 1 | SO44760 | 2022-08-14 | 171.76 | 2171.29 | 2146.96 |
SO44760_2 | 7817-4F63-9C | PO13717175675 | 100 | 287 | 272 | 473 | 4 | 2022-08-19 | 551.81 | 13.80 | 2022-08-07 | 3 | 181.49 | 1 | 551.81 | 2 | SO44760 | 2022-08-14 | 44.15 | 544.46 | 183.94 |
SO44760_3 | 7817-4F63-9C | PO13717175675 | 100 | 287 | 312 | 473 | 4 | 2022-08-19 | 2146.96 | 53.67 | 2022-08-07 | 1 | 2171.29 | 1 | 2146.96 | 3 | SO44760 | 2022-08-14 | 171.76 | 2171.29 | 2146.96 |
SO44760_4 | 7817-4F63-9C | PO13717175675 | 100 | 287 | 275 | 473 | 4 | 2022-08-19 | 356.90 | 8.92 | 2022-08-07 | 1 | 352.14 | 1 | 356.90 | 4 | SO44760 | 2022-08-14 | 28.55 | 352.14 | 356.90 |
SO45541_1 | CC17-443A-83 | PO13717172787 | 100 | 287 | 220 | 473 | 4 | 2022-11-17 | 40.37 | 1.01 | 2022-11-05 | 2 | 12.03 | 1 | 40.37 | 1 | SO45541 | 2022-11-12 | 3.23 | 24.06 | 20.19 |
SO45541_2 | CC17-443A-83 | PO13717172787 | 100 | 287 | 232 | 473 | 4 | 2022-11-17 | 28.84 | 0.72 | 2022-11-05 | 1 | 31.72 | 1 | 28.84 | 2 | SO45541 | 2022-11-12 | 2.31 | 31.72 | 28.84 |
SO46347_1 | 33F9-487C-A3 | PO13717117301 | 100 | 287 | 264 | 473 | 4 | 2023-02-17 | 183.94 | 4.60 | 2023-02-05 | 1 | 181.49 | 1 | 183.94 | 1 | SO46347 | 2023-02-12 | 14.72 | 181.49 | 183.94 |
SO46347_2 | 33F9-487C-A3 | PO13717117301 | 100 | 287 | 253 | 473 | 4 | 2023-02-17 | 357.16 | 8.93 | 2023-02-05 | 2 | 176.20 | 1 | 357.16 | 2 | SO46347 | 2023-02-12 | 28.57 | 352.40 | 178.58 |
SO46347_3 | 33F9-487C-A3 | PO13717117301 | 100 | 287 | 340 | 473 | 4 | 2023-02-17 | 419.46 | 10.49 | 2023-02-05 | 1 | 413.15 | 1 | 419.46 | 3 | SO46347 | 2023-02-12 | 33.56 | 413.15 | 419.46 |
SO46347_4 | 33F9-487C-A3 | PO13717117301 | 100 | 287 | 272 | 473 | 4 | 2023-02-17 | 183.94 | 4.60 | 2023-02-05 | 1 | 181.49 | 1 | 183.94 | 4 | SO46347 | 2023-02-12 | 14.72 | 181.49 | 183.94 |
SO47386_1 | 53D3-4CF9-BD | PO13717112244 | 100 | 287 | 343 | 473 | 4 | 2023-05-20 | 469.79 | 11.74 | 2023-05-08 | 1 | 486.71 | 1 | 469.79 | 1 | SO47386 | 2023-05-15 | 37.58 | 486.71 | 469.79 |
SO47386_2 | 53D3-4CF9-BD | PO13717112244 | 100 | 287 | 242 | 473 | 4 | 2023-05-20 | 780.82 | 19.52 | 2023-05-08 | 1 | 722.26 | 1 | 780.82 | 2 | SO47386 | 2023-05-15 | 62.47 | 722.26 | 780.82 |
SO47386_3 | 53D3-4CF9-BD | PO13717112244 | 100 | 287 | 221 | 473 | 4 | 2023-05-20 | 20.19 | 0.50 | 2023-05-08 | 1 | 13.88 | 1 | 20.19 | 3 | SO47386 | 2023-05-15 | 1.61 | 13.88 | 20.19 |
SO47386_4 | 53D3-4CF9-BD | PO13717112244 | 100 | 287 | 424 | 473 | 4 | 2023-05-20 | 214.24 | 5.36 | 2023-05-08 | 1 | 158.53 | 1 | 214.24 | 4 | SO47386 | 2023-05-15 | 17.14 | 158.53 | 214.24 |
SO47386_5 | 53D3-4CF9-BD | PO13717112244 | 100 | 287 | 239 | 473 | 4 | 2023-05-20 | 780.82 | 19.52 | 2023-05-08 | 1 | 722.26 | 1 | 780.82 | 5 | SO47386 | 2023-05-15 | 62.47 | 722.26 | 780.82 |
SO47386_6 | 53D3-4CF9-BD | PO13717112244 | 100 | 287 | 439 | 473 | 4 | 2023-05-20 | 780.82 | 19.52 | 2023-05-08 | 1 | 722.26 | 1 | 780.82 | 6 | SO47386 | 2023-05-15 | 62.47 | 722.26 | 780.82 |
SO47386_7 | 53D3-4CF9-BD | PO13717112244 | 100 | 287 | 403 | 473 | 4 | 2023-05-20 | 97.18 | 2.43 | 2023-05-08 | 4 | 17.98 | 1 | 97.18 | 7 | SO47386 | 2023-05-15 | 7.77 | 71.91 | 24.29 |
SO47386_8 | 53D3-4CF9-BD | PO13717112244 | 100 | 287 | 321 | 473 | 4 | 2023-05-20 | 469.79 | 11.74 | 2023-05-08 | 1 | 486.71 | 1 | 469.79 | 8 | SO47386 | 2023-05-15 | 37.58 | 486.71 | 469.79 |
SO53490_1 | 48D0-4BD6-8A | PO13717132596 | 100 | 287 | 243 | 473 | 4 | 2024-05-19 | 858.90 | 21.47 | 2024-05-07 | 1 | 868.63 | 1 | 858.90 | 1 | SO53490 | 2024-05-14 | 68.71 | 868.63 | 858.90 |
SO53490_2 | 48D0-4BD6-8A | PO13717132596 | 100 | 287 | 520 | 473 | 4 | 2024-05-19 | 31.58 | 0.79 | 2024-05-07 | 1 | 23.37 | 1 | 31.58 | 2 | SO53490 | 2024-05-14 | 2.53 | 23.37 | 31.58 |
SO53490_3 | 48D0-4BD6-8A | PO13717132596 | 100 | 287 | 482 | 473 | 4 | 2024-05-19 | 16.18 | 0.40 | 2024-05-07 | 3 | 3.36 | 1 | 16.18 | 3 | SO53490 | 2024-05-14 | 1.29 | 10.09 | 5.39 |
SO53490_4 | 48D0-4BD6-8A | PO13717132596 | 100 | 287 | 240 | 473 | 4 | 2024-05-19 | 1717.80 | 42.95 | 2024-05-07 | 2 | 868.63 | 1 | 1717.80 | 4 | SO53490 | 2024-05-14 | 137.42 | 1737.27 | 858.90 |
SO53490_5 | 48D0-4BD6-8A | PO13717132596 | 100 | 287 | 440 | 473 | 4 | 2024-05-19 | 858.90 | 21.47 | 2024-05-07 | 1 | 868.63 | 1 | 858.90 | 5 | SO53490 | 2024-05-14 | 68.71 | 868.63 | 858.90 |
SO58935_1 | 19F2-4C39-93 | PO13717119913 | 100 | 287 | 482 | 473 | 4 | 2024-08-18 | 10.79 | 0.27 | 2024-08-06 | 2 | 3.36 | 1 | 10.79 | 1 | SO58935 | 2024-08-13 | 0.86 | 6.72 | 5.39 |
SO58935_2 | 19F2-4C39-93 | PO13717119913 | 100 | 287 | 434 | 473 | 4 | 2024-08-18 | 356.90 | 8.92 | 2024-08-06 | 1 | 360.94 | 1 | 356.90 | 2 | SO58935 | 2024-08-13 | 28.55 | 360.94 | 356.90 |
SO58935_3 | 19F2-4C39-93 | PO13717119913 | 100 | 287 | 408 | 473 | 4 | 2024-08-18 | 72.16 | 1.80 | 2024-08-06 | 1 | 53.40 | 1 | 72.16 | 3 | SO58935 | 2024-08-13 | 5.77 | 53.40 | 72.16 |
SO58935_4 | 19F2-4C39-93 | PO13717119913 | 100 | 287 | 287 | 473 | 4 | 2024-08-18 | 202.33 | 5.06 | 2024-08-06 | 1 | 204.63 | 1 | 202.33 | 4 | SO58935 | 2024-08-13 | 16.19 | 204.63 | 202.33 |
SO58935_5 | 19F2-4C39-93 | PO13717119913 | 100 | 287 | 436 | 473 | 4 | 2024-08-18 | 713.80 | 17.84 | 2024-08-06 | 2 | 360.94 | 1 | 713.80 | 5 | SO58935 | 2024-08-13 | 57.10 | 721.89 | 356.90 |
SO58935_6 | 19F2-4C39-93 | PO13717119913 | 100 | 287 | 463 | 473 | 4 | 2024-08-18 | 58.78 | 1.47 | 2024-08-06 | 4 | 9.16 | 1 | 58.78 | 6 | SO58935 | 2024-08-13 | 4.70 | 36.64 | 14.69 |
SO65239_1 | 05CB-4E4A-AC | PO13717153710 | 100 | 287 | 483 | 473 | 4 | 2024-11-17 | 72.00 | 1.80 | 2024-11-05 | 1 | 44.88 | 1 | 72.00 | 1 | SO65239 | 2024-11-12 | 5.76 | 44.88 | 72.00 |
SO65239_2 | 05CB-4E4A-AC | PO13717153710 | 100 | 287 | 546 | 473 | 4 | 2024-11-17 | 37.25 | 0.93 | 2024-11-05 | 1 | 27.57 | 1 | 37.25 | 2 | SO65239 | 2024-11-12 | 2.98 | 27.57 | 37.25 |
SO71811_1 | F24F-44FF-A5 | PO13717180066 | 100 | 287 | 418 | 473 | 4 | 2025-02-17 | 356.90 | 8.92 | 2025-02-05 | 1 | 360.94 | 1 | 356.90 | 1 | SO71811 | 2025-02-12 | 28.55 | 360.94 | 356.90 |
SO71811_2 | F24F-44FF-A5 | PO13717180066 | 100 | 287 | 434 | 473 | 4 | 2025-02-17 | 1070.69 | 26.77 | 2025-02-05 | 3 | 360.94 | 1 | 1070.69 | 2 | SO71811 | 2025-02-12 | 85.66 | 1082.83 | 356.90 |
SO71811_3 | F24F-44FF-A5 | PO13717180066 | 100 | 287 | 287 | 473 | 4 | 2025-02-17 | 404.66 | 10.12 | 2025-02-05 | 2 | 204.63 | 1 | 404.66 | 3 | SO71811 | 2025-02-12 | 32.37 | 409.25 | 202.33 |
SO71811_4 | F24F-44FF-A5 | PO13717180066 | 100 | 287 | 436 | 473 | 4 | 2025-02-17 | 713.80 | 17.84 | 2025-02-05 | 2 | 360.94 | 1 | 713.80 | 4 | SO71811 | 2025-02-12 | 57.10 | 721.89 | 356.90 |
SO71811_5 | F24F-44FF-A5 | PO13717180066 | 100 | 287 | 214 | 473 | 4 | 2025-02-17 | 20.99 | 0.52 | 2025-02-05 | 1 | 13.09 | 1 | 20.99 | 5 | SO71811 | 2025-02-12 | 1.68 | 13.09 | 20.99 |
Generated 2025-04-06 18:04:55.517 UTC